Tabela MealTypeText

Definicja tabeli MealTypeText

Name

MealTypeText

Code

MealTypeText

Comment

Typy posilków takie jak: sniadanie, obiad, kolacja itp. oraz ich ramy czasowe (StartT i StopT
Tabela Opisowa.


Lista kolumn tabeli MealTypeText

Name

Code

MealTypeID

MealTypeID

LanguageID

LanguageID

Code

Code

FullName

FullName

ShortName

ShortName

Description

Description


Kolumna MealTypeID tabeli MealTypeText

Definicja kolumny MealTypeID tabeli MealTypeText

Name

MealTypeID

Code

MealTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna LanguageID tabeli MealTypeText

Definicja kolumny LanguageID tabeli MealTypeText

Name

LanguageID

Code

LanguageID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Code tabeli MealTypeText

Definicja kolumny Code tabeli MealTypeText

Name

Code

Code

Code

Data Type

VARCHAR2(13)

Mandatory

No

Comment

PL: Kod wiersza
EN: Record's code
DE: Der code des Rekord


Kolumna FullName tabeli MealTypeText

Definicja kolumny FullName tabeli MealTypeText

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

PL: Pelna nazwa wiersza
EN: Record's full name
DE: Der voll Name des Rekord


Kolumna ShortName tabeli MealTypeText

Definicja kolumny ShortName tabeli MealTypeText

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(32)

Mandatory

No

Comment

PL: Skrócona nazwa wiersza
EN: Record's short name
DE: Der kurz Name des Rekord


Kolumna Description tabeli MealTypeText

Definicja kolumny Description tabeli MealTypeText

Name

Description

Code

Description

Data Type

VARCHAR2(48)

Mandatory

No

Comment

Opis - do oblugi tej tabeli przez mechanizm slownikowy w MA


Lista kluczy tabeli MealTypeText

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli MealTypeText

Definicja klucza Identifier_1 tabeli MealTypeText

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment